Running the 3 Scenario Comparison report

Use this report to compare three scenarios for a single year.

To run the 3 Scenario Comparison report:

  1. In the Fin Plan Admin or Fin Plan task pane, in the Scenario Management section, click Scenario Analysis, and double-click 3 Scenario Comparison.

  2. Refresh the data in the report by doing one of the following:

    • In the Admin ribbon tab, in the Workbook Options group, click Refresh Data.

    • Press F9.

  3. In the Refresh Variables dialog, select the following, and click OK:

    NOTE: To return all results, leave the selections blank, and click OK.

    Options Description
    Select Forecast Year of Comparison Select the forecast year for the scenarios to compare.
    Select Scenario of Comparison
    1. Click Choose Value.
    2. In the Choose Value dialog, select the scenario to compare the first and second scenario to.
    3. Click OK.
    Select Scenario 1 for Comparison
    1. Click Choose Value.
    2. In the Choose Value dialog, select the first scenario to compare to the scenario of comparison.
    3. Click OK.
    Select Scenario 2 for Comparison
    1. Click Choose Value.
    2. In the Choose Value dialog, select the second scenario to compare to scenario of comparison.
    3. Click OK.

  4. At the top of the report, in the Financial Planning Year cell, select the planning year data to view.

  5. To save the report, in the Main ribbon tab, click Save.